TOraSession Members

Properties

Name	Description
AutoCommit	Used to permit or prevent permanent updates, insertions, and deletions of data associated with the current transaction against the database server.
ConnectDialog (inherited from TCustomDAConnection)	Allows to link a TCustomConnectDialog component.
Connected	Used to indicate if the database connection is active.
ConnectMode	Used to specify the system privileges to use when a user connects to the server.
ConnectPrompt	Used to supply a prompt for a name and password.
ConnectString (inherited from TCustomDAConnection)	Used to specify the connection information, such as: UserName, Password, Server, etc.
ConvertEOL (inherited from TCustomDAConnection)	Allows customizing line breaks in string fields and parameters.
Debug	Used to display SQL statements being executed with their parameter values and data types.
Home	Used to specify the Oracle client to be used in the application.
HomeName	Used to select the Oracle client to use with the application.
HttpOptions	Used to set up the HTTP options.
InternalName	Used to get or set the client database name that will be recorded when performing global transactions.
InTransaction (inherited from TCustomDAConnection)	Indicates whether the transaction is active.
LastError	Used to get an error code which resulted from previous call to the OCI interface function.
LDA	Provides a pointer to Oracle 7 login data area of the current connection.
LoginPrompt (inherited from TCustomDAConnection)	Specifies whether a login dialog appears immediately before opening a new connection.
OCICallStyle	Indicates the set of OCI routines used.
OCISvcCtx	Used to return Oracle 8 service context handle of the current connection.
Options	Used to specify the behaviour of a TOraSession object.
OracleVersion	Used to get Oracle server version number as string.
Password	Used to specify a password for a connection.
Pooling (inherited from TCustomDAConnection)	Enables or disables using connection pool.
PoolingOptions	Used to specify the behaviour of connection pool.
ProxySession	Used to enable multiple user sessions within a single database session.
Schema	Used to change the current schema of the session to the specified schema.
Server	Contains the server name.
SQL	Uses embedded TOraSQL object to execute any SQL statement.
SSLOptions	Used to set up the SSL options.
ThreadSafety	Used to allow the usage of the OCI in multi-threaded environment.
Username	Contains username.

Methods

Name	Description
ApplyUpdates (inherited from TCustomDAConnection)	Overloaded. Applies changes in datasets.
AssignConnect	Shares database connection between the TOraSession components.
AssignLDA	The method is used to assign LDA handle.
AssignSvcCtx	Overloaded. The method is used to assign service context handle.
ChangePassword	Changes the password of an account to the new password.
Commit (inherited from TCustomDAConnection)	Commits current transaction.
Connect (inherited from TCustomDAConnection)	Establishes a connection to the server.
CreateSQL (inherited from TCustomDAConnection)	Creates a component for queries execution.
Disconnect (inherited from TCustomDAConnection)	Performs disconnect.
ExecProc (inherited from TCustomDAConnection)	Allows to execute stored procedure or function providing its name and parameters.
ExecProcEx (inherited from TCustomDAConnection)	Allows to execute a stored procedure or function.
ExecSQL (inherited from TCustomDAConnection)	Executes a SQL statement with parameters.
ExecSQLEx (inherited from TCustomDAConnection)	Executes any SQL statement outside the TQuery or TSQL components.
GetDatabaseNames (inherited from TCustomDAConnection)	Returns a database list from the server.
GetKeyFieldNames (inherited from TCustomDAConnection)	Provides a list of available key field names.
GetSequenceNames	Provides the names of available sequences.
GetStoredProcNames (inherited from TCustomDAConnection)	Returns a list of stored procedures from the server.
GetTableNames (inherited from TCustomDAConnection)	Provides a list of available tables names.
MonitorMessage (inherited from TCustomDAConnection)	Sends a specified message through the TCustomDASQLMonitor component.
ParamByName	Provides access to OUT parameters and their values after processing SQL statement with ExecSQL or stored procedure with ExecProc.
Ping (inherited from TCustomDAConnection)	Used to check state of connection to the server.
RemoveFromPool (inherited from TCustomDAConnection)	Marks the connection that should not be returned to the pool after disconnect.
Rollback (inherited from TCustomDAConnection)	Discards all current data changes and ends transaction.
RollbackToSavepoint	Cancels all updates for the current transaction.
Savepoint	Defines a point in the transaction to which you can roll back later.
StartTransaction	Overloaded. Begins a new user transaction against the database server.

Events

Name	Description
OnConnectChange	Occurs after Connected property was changed.
OnConnectionLost (inherited from TCustomDAConnection)	This event occurs when connection was lost.
OnError (inherited from TCustomDAConnection)	This event occurs when an error has arisen in the connection.
OnFailover	Occurs when Transparent Application Failover (TAF) seamlessly attempts to failover to another Oracle instance.
OnInfoMessage	The event occurs if the server returned the OCI_SUCCESS_WITH_INFO error.

Request Support

DAC Forum

Provide Feedback